Collapse All Expand All

Dates as Parameters

When dates are used as parameters to API calls, only the date portion is applicable.   Any times provided in the parameters will be truncated.   The remaining dates are then searched inclusively.  For example, when dates are used as a "FROM" parameter, a default time of 00:00:00 is used.  When dates are used as a "TO" parameter, a default time of 23:59:59 is used.  

Examples:

To find all invoices for a December 2nd 2011, enter 12/2/2011 in both the InvoicedFrom and InvoicedTo parameters.

To find all sales for the month of May in 2013, enter 5/1/2013 as the SaleDateFrom parameter and 5/31/2013 in the SaleDateTo parameter.

 

Dates in XML

When dates are used in XML, for example when adding new records or viewing the XML results from a list request, the dates must adhere to the XML date format.  The format for dates in XML will be

YYYY-MM-DDTHH:MM:SS

Examples:

November 27th, 2011 at 2:31:01 PM would be shown as 2011-11-27T14:31:01

April 12th, 2013 at 9:05:41 AM would be shown as 2012-04-12T09:05:41